﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_CM_UpdateLinkman]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_CM_UpdateLinkman];
GO
CREATE PROCEDURE [dbo].[sproc_CM_UpdateLinkman]
@ID int,
@ClientID int,
@name nvarchar(50),
@mobile nvarchar(50),
@telephone nvarchar(50),
@position nvarchar(50),
@email nvarchar(50),
@gender bit,
@description nvarchar(50),
@address nvarchar(100),
@family nvarchar(200)

AS

    UPDATE UDS_CM_Linkman SET 
        ClientID=@ClientID,
        Name=@name,
        mobile=@mobile,
        telephone=@telephone,
        position=@position,
        email=@email,
        gender=@gender,
        description=@description,
        address=@address,
        family=@family
    WHERE ID=@ID